/* create table jiveSecurityAuditLog */
CREATE TABLE jiveSecurityAuditLog (
  msgID                 INTEGER         NOT NULL,
  username              NVARCHAR(64)    NOT NULL,
  entryStamp            BIGINT          NOT NULL,
  summary               NVARCHAR(255)   NOT NULL,
  node                  NVARCHAR(255)   NOT NULL,
  details               NTEXT,
  CONSTRAINT jiveSecAuditLog_pk PRIMARY KEY (msgID)
);
/
CREATE INDEX jiveSecAuditLog_tstamp_idx ON jiveSecurityAuditLog (entryStamp);
/
CREATE INDEX jiveSecAuditLog_uname_idx ON jiveSecurityAuditLog (username);
/
UPDATE jiveVersion set version=16 where name = 'openfire';
/